Document All Calculated Aliases In An Access Database |

[Solved] Document All Calculated Aliases In An Access Database | | Vb - Code Explorer | yomemimo.com
Question : Document all CALCULATED & ALIASES in an Access database | LOG | ACC

Answered by : shane-eckel

SELECT mQ.Name1 AS FieldName
     , mo.Name AS QryName
     , mQ.Expression  
 FROM MSysObjects AS mo
     INNER JOIN MSysQueries AS mQ
         ON mo.Id = mQ.ObjectId  
 WHERE ( (mQ.Name1 Is Not Null)
     AND (left(mo.Name,1) Not IN ("~","{"))
     AND (mQ.Expression Is Not Null)
     AND (mQ.Attribute=6) )  
 ORDER BY mQ.Name1
     , mo.Name;

Source : http://www.rogersaccesslibrary.com/forum/document-calculated-fields-in-queries_topic619.html | Last Update : Thu, 13 Oct 22

Answers related to document all calculated aliases in an access database | log | acc

Code Explorer Popular Question For Vb